--
-- Description: View for displaying the list of cabs.
-- Date created: 12 May 2008
--

set ANSI_NULLS on
set QUOTED_IDENTIFIER on
go

--
-- drop the view if it exists and recreate it.
--
if exists
(
	select * 
	from sys.views
	where object_id = OBJECT_ID(N'[dbo].[Cabs_vw]')
)
begin
	drop view [dbo].[Cabs_vw]
end
go

create view [dbo].[Cabs_vw] 
as
	select 
	C.[CabID]
	, C.[CabSizeInBytes]
	, C.[CabFileNameWithPath]
	, C.[DateCreated]
	, C.[DateModified]
	, C.[EventID]
	, ET.[EventTypeName]
	from [dbo].[Cabs] C (nolock)
	inner join [dbo].[EventTypes] ET (nolock)
		on C.EventTypeID = ET.EventTypeID
go
